At 5:10 +0300 on 4/5/98, Richard Lynch wrote:
> Now, I really want the result from the first query, *AND* the count from
> the second query.
>
> select name, count(name) from users;
>
> would be fine, even if it did give me the count too many times, but it
> won't work.
>
> So. how does one get both the data and the count as results in table format
> from a query?
Define a function, and select both it and the data...
CREATE FUNCTION cnt_usr() RETURNS int4
AS 'SELECT COUNT(name) FROM users'
LANGUAGE 'sql';
SELECT name, cnt_usr()
FROM users;
You do realize, however, that it will do the counting over and over for
each line?
Herouth